package com.example.back.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

import com.example.common.entity.CMS;

public interface ConfigMapper {
    
    
    @Select("select a.title as Title,"
    + " avg(b.referral_price_money) as TitleNetPrice,avg(b.img_text_price_money) as TitleImgTextPrice,"
    + " avg(b.phone_price_money) as TitlePhonePrice,avg(b.video_price_money) as TitleVideoPrice"
    + " from doctor_base_info a"
    + " inner join doctor_config b on a.dc_id = b.dc_id_bigint"
    + " group by a.title")
    List<Map<String, Object>> TitleGroup();

    @Select("select id_bigint as id,n_content_text as nContent,types_int as types from sys_cms where types_int = 3")
    CMS findCms();
}
